Main
Kyle PATRICK Simpson
ETL/ELT Pipeline Support Specialist | Researrch Analyst | Data Technician
Data analyst with 5+ years experience supporting data pipelines, automating workflows, and integrating datasets using SQL, Python, R, and Excel/Googlesheets. Strong focus on data quality, reporting accuracy, and translating complex data into operational decisions. Experience across Non-profit, Hospitality/Retail, Public Health, and Environmental Research sectors.
Relevant Work History
Inventory & Quality Assurance Analyst
M2 by Matcha Matcha
Toronto, Ont
2024
- Developed an accurate inventory reporting system using R, SQL, and Excel/Google Sheets via triangulation of sales, purchasing, and inventory records.
- Maintained relational database of supplier, product, and customer information acquired via information requests, exported datasets, APIs, and web-scraping.
- Facilitated working relationships with suppliers to ensure consistency of quality, supply, and pricing.
Data Migration Technician
Lions Foundation of Canada Dog Guides
Oakville, Ont
2022
- Consulted on migration of 4 months financial and client data from Excel & Quickbooks into Salesforce.
- Creation of automated workflows using VBA in Excel for the purpose of data compiling, cleaning, and validation.
- Reached out to individual donor and/or members of the finance team to amend irregularities and/or obtain missing data as required.
Data & Systems Administrator
Accident Compensation Commission, NZ
Dunedin, NZ
2022 - 2021
- Demonstrated ability to quickly learn NZ health care policy as it pertains to various work environments and accident coverage.
- Researched and identified various employer entities to ensure accurate attribution of benefits.
- Employed analytical skills to proactively identify and resolve system irregularities and errors.
Managing Director / Data Systems Consultant
Bar Squire Beverage Consultancy Services
Wellington, NZ
2021 - 2020
- Provided data driven consultation to bars, restaurants, and events.
- Creation and maintenance of relational databases containing client information, cocktail recipes, product information, bar & restaurant points of service.
- Use of SQL, Excel, R, and Python to wrangle data.
Research Analyst
Greenback Ltd.
Auckland, NZ
2020 - 2019
- Conducted thorough literature reviews of various subjects so as to educate myself and team members on relevant subject matter, data types, and stakeholders.
- Identified various sources of private and publicly available environmental data via information requests, web-scraping, and API pulls.
- Collaborated directly with the application development team on data implementation and structuring.